1 <?php
2 error_reporting(0);
3 require("../includes/config.php");
4 session_start();
5 if(isset($_SESSION['manufacturer_login'])) {
6 $id = $_GET['id'];
7 $pro_id = $orderQuantity = $availQuantity = "";
8 $queryAvailQuantity = "SELECT products.pro_id AS pro_id,products.quantity AS quantity FROM order_items,products WHERE products.pro_id=order_items.pro_id AND order_items.order_id='$id' AND products.quantity IS NOT NULL";
9 $resultAvailQuantity = mysqli_query($con,$queryAvailQuantity);
10 $queryOrderQuantity = "SELECT quantity AS q,pro_id AS p FROM order_items WHERE order_id='$id'";
11 $resultOrderQuantity = mysqli_query($con,$queryOrderQuantity);
12 while($rowAvailQuantity = mysqli_fetch_array($resultAvailQuantity)){
13 $availProId[] = $rowAvailQuantity['pro_id'];
14 $availQuantity[] = $rowAvailQuantity['quantity'];
15 }
16 while($rowOrderQuantity = mysqli_fetch_array($resultOrderQuantity)){
17 $orderProId[] = $rowOrderQuantity['p'];
18 $orderQuantity[] = $rowOrderQuantity['q'];
19 }
20 foreach(array_combine($orderProId, $orderQuantity) as $p => $q) {
21 foreach(array_combine($availProId,$availQuantity) as $proId => $quantity) {
22 if($p == $proId) {
23 $total = $quantity-$q;
24 if($total >= 0 ) {
25 $queryUpdateQuantity = "UPDATE products SET quantity='$total' WHERE pro_id='$proId'";
26 $result = mysqli_query($con,$queryUpdateQuantity);
27 }
28 }
29 }
30 }
31 if(!isset($result) || !$result){
32 echo "<script> alert(\"You don't have enough stock to approve this order\"); </script>";
33 header("refresh:0;url=view_orders.php");
34 }
35 else {
36 $queryConfirm = "UPDATE orders SET approved=1 WHERE order_id='$id'";
37 if(mysqli_query($con,$queryConfirm)) {
38 echo "<script> alert(\"Order has been confirmed\"); </script>";
39 header( "refresh:0;url=view_orders.php" );
40 }
41 else {
42 echo "<script> alert(\"There was some issue in approving order.\"); </script>";
43 header( "refresh:0;url=view_orders.php" );
44 }
45 }
46 }
47 else {
48 header('Location:../index.php');
49 }
50 ?>